How to use like clause? Is it possible to use it with INT data type variable?

Question

Abhishek Srivasatava · Answer

and Hi Jonas,and Yes, it is possible to use like command with Integer data typeand verified in SQL server 2008and .SELECTand *FROM Ee_empl_cat4whereprsn_intn_idand  LIKE '10%'Use of like statement with different Wildcard :
SELECT DISTICTand  A.PRSN_ADHAR_NUM
FROM ADHAR 
WHERE NAME LIKE 'P%' -- this statement fetch all those record whose name is start with ‘P’. 
OR City LIKE '%A' -- this statement fetch all those record whose name is ends with ‘A’.
OR City LIKE '%ank%'-- this statement fetch all those adhar number whose name contains ‘ank’ in between their number. 
OR City NOT LIKE 's%'
OR City LIKE ‘R_S_I_E_H’ -- this statement is used to find the city name start with R followed by any text, followed by ‘S’
followed by any text, followed by I followed by any text, followed by E followed
by any text and string last letter will be H. Wildcard ( _ )and  is like a substitution for any alphabet.
ORand  Cityand  LIKE '[abc]' -- fetch all those city name which start with a,b,c.
ORand  Cityand  LIKE '[a-c]' -- fetch all those city name which start with a,b,c.
and

forum

How to use like clause? Is it possible to use it with INT data type variable?

Jonas Stuart

Can you answer this question?

1 Answers

Liked By